Exploratory Data Analysis - US Food & Drug Administration

Github - https://github.com/hariomvyas/UMBC/blob/main/Data601/Project3/Vyas_Hariom_Project3.ipynb

Data Source 1 –

Data Source - https://datadashboard.fda.gov/ora/cd/inspections.htm
Data Name – U.S. Food & Drug Administration - Inspections Details
Data was  provided by Professor. It is free to download and legal to access. Documented EDA of Data is not available.
Data Size – Rows (222697), Columns (8), Size (9.09 MB)

Data Source 2 –

Data Source - https://datadashboard.fda.gov/ora/cd/inspections.htm
Data Name – U.S. Food & Drug Administration - Inspections Citations Details
Data was  provided by Professor. It is free to download and legal to access. Documented EDA of Data is not available.
Data Size – Rows (257624), Columns (14), Size (17.0 MB)

Breakdown of the project –

1. Loading dataset, Combining two datasets, and Cleaning.
2. Finding relationship between features of dataset
3. Presenting Hypothesis and Visulizations based on the it.

3Ps Problem faced by FDA - Procedure, Pest & Protocol

Pest Control is One of the Biggest Problem in Maryland

Procedures are not being followed in Biologics, Devices, Drugs, and Veterinary

Yes, Looking at the volume of Short & Long Decriptions on Procedures not being followed properly shows our thesis is correct.

Sanitation & Bugs are the biggest problem in Food Industry

Yes, Looking at the volume of Short & Long Decriptions on Procedures not being followed properly shows our thesis is correct.

Storage is one of main issues of Tobacco Industry

Where does Most Inspections Happens Domestic/Foreign

Which state has more Inspections till now?

Has Inspections decresed overtime?

Yes, Number of inspections has decresed overtime
- Yearly -> Yes
- Domestic/Foreign (Yearly) -> Yes
- State-wise (Yearly) -> Yes

Does Classification has any relation with Product Type or Project Area

Yes, Classifications are changing according to Product Type and Project area
Product Type - Observations can see that some of the product type such as Food/Cosmetic has higher number of VAI (Voluntary Action Indicated) Classification.

Project Area - It can be seen from the observations that majority of Project Areas has VAI (Voluntary Action Indicated) while there are some outliers such as Tobacco Post-Market Activities, Pesticides and Chemical Contaminants, Prescription Drug Advertising and Labelling and Vaccines and Allergenic Products where NAI (No Action Indicated) is on higher end.

Does Classification difffers state-wise

Yes, Classification differes state-wise.
This can be results of number of inspections in that state. If the number of inspections are high then there are diverse classifications.